package smartcommunityserver.mapper;



import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import smartcommunityserver.bean.CarCountBean2;

import java.util.List;

/**
 * @author renmin
 */
@Mapper
public interface CarCountMapper2 {
    @Select("SELECT\n" +
            "    DATE_FORMAT(time_ltz,'%Y-%m-%d %H') as time\n" +
            "        ,SUM(in_cnt+out_cnt) as total\n" +
            "FROM dws_sca.dws_summary_cars_log\n" +
            "where  DATE_FORMAT(window_start, '%Y-%m-%d') = '2025-08-21'\n" +
            "GROUP BY  DATE_FORMAT(time_ltz,'%Y-%m-%d %H');")
    List<CarCountBean2> carCountMapper2();
}
